/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50724
 Source Host           : localhost
 Source Database       : gateway

 Target Server Type    : MySQL
 Target Server Version : 50724
 File Encoding         : utf-8

 Date: 12/29/2018 11:30:38 AM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `api_define`
-- ----------------------------
DROP TABLE IF EXISTS `api_define`;
CREATE TABLE `api_define` (
  `id` varchar(50) NOT NULL,
  `parnter_code` varchar(10) NOT NULL COMMENT '商户编号',
  `path` varchar(255) NOT NULL,
  `service_id` varchar(50) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `retryable` tinyint(1) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL,
  `strip_prefix` int(11) DEFAULT NULL,
  `api_name` varchar(255) DEFAULT NULL,
  `fallback_url` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`,`parnter_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `api_define`
-- ----------------------------
BEGIN;
INSERT INTO `api_define` VALUES ('ooo', 'xs', '/ooo/**', 'dashboard', 'http://localhost:35124', '0', '1', '1', '配置平台', null, '2018-12-18 17:13:10', '2018-12-18 17:13:14'), ('pppp', 'yl', '/pppp/**', 'mapping', 'http://localhost:35897', '0', '1', '1', '报文转换', null, '2018-12-18 17:09:57', '2018-12-18 17:10:00');
COMMIT;

-- ----------------------------
--  Table structure for `msg_in_conf`
-- ----------------------------
DROP TABLE IF EXISTS `msg_in_conf`;
CREATE TABLE `msg_in_conf` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `api_id` varchar(10) NOT NULL COMMENT '接口表id',
  `param_name` varchar(50) DEFAULT NULL COMMENT '字段名',
  `param_note` varchar(50) DEFAULT NULL COMMENT '字段注释',
  `param_length` int(9) DEFAULT NULL COMMENT '字段长度',
  `encrypt_strategy` int(3) NOT NULL DEFAULT '0' COMMENT '参数0，1，2，3，4。0表示这个字段不需要处理。1的话表示这个字段和他包含的报文体需要加密，2的话表示这个字段和他包含的报文体需要签名,3表示这个字段需要解密，4表示这个字段需要验证签名',
  `is_empty` tinyint(1) DEFAULT NULL COMMENT '是否可空',
  `is_activated` tinyint(1) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `msg_in_type` varchar(255) DEFAULT NULL,
  `parent_node` varchar(255) DEFAULT NULL,
  `param_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`,`api_id`)
) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `msg_in_conf`
-- ----------------------------
BEGIN;
INSERT INTO `msg_in_conf` VALUES ('97', 'pppp', 'modelVersion', '', '255', '0', '0', '1', '2018-12-21 05:17:45', '2018-12-21 05:17:45', null, '', 'java.lang.String'), ('98', 'pppp', 'groupId', '', '255', '0', '0', '1', '2018-12-21 05:17:45', '2018-12-21 05:17:45', null, '', 'java.lang.String'), ('99', 'pppp', 'artifactId', '', '255', '0', '0', '1', '2018-12-21 05:17:45', '2018-12-21 05:17:45', null, '', 'java.lang.String'), ('100', 'pppp', 'version', '', '255', '0', '0', '1', '2018-12-21 05:17:45', '2018-12-21 05:17:45', null, '', 'java.lang.String'), ('101', 'pppp', 'name', '', '255', '0', '0', '1', '2018-12-21 05:17:45', '2018-12-21 05:17:45', null, '', 'java.lang.String'), ('102', 'pppp', 'description', '', '255', '0', '0', '1', '2018-12-21 05:17:45', '2018-12-21 05:17:45', null, '', 'java.lang.String'), ('103', 'pppp', 'parent', '', '255', '0', '0', '1', '2018-12-21 05:17:45', '2018-12-21 05:17:45', null, '', 'java.util.LinkedHashMap'), ('104', 'pppp', 'dependencies', '', '255', '0', '0', '1', '2018-12-21 05:17:45', '2018-12-21 05:17:45', null, '', 'java.util.LinkedHashMap'), ('105', 'pppp', 'build', '', '255', '0', '0', '1', '2018-12-21 05:17:45', '2018-12-21 05:17:45', null, '', 'java.util.LinkedHashMap'), ('106', 'pppp', 'groupId', '', '255', '0', '0', '1', '2018-12-21 05:17:45', '2018-12-21 05:17:45', null, 'parent', 'java.lang.String'), ('107', 'pppp', 'artifactId', '', '255', '0', '0', '1', '2018-12-21 05:17:45', '2018-12-21 05:17:45', null, 'parent', 'java.lang.String'), ('108', 'pppp', 'version', '', '255', '0', '0', '1', '2018-12-21 05:17:45', '2018-12-21 05:17:45', null, 'parent', 'java.lang.String'), ('109', 'pppp', 'dependency', '', '255', '0', '0', '1', '2018-12-21 05:17:45', '2018-12-21 05:17:45', null, 'dependencies', 'java.util.ArrayList'), ('110', 'pppp', 'plugins', '', '255', '0', '0', '1', '2018-12-21 05:17:45', '2018-12-21 05:17:45', null, 'build', 'java.util.LinkedHashMap'), ('111', 'pppp', 'plugin', '', '255', '0', '0', '1', '2018-12-21 05:17:45', '2018-12-21 05:17:45', null, 'plugins', 'java.util.LinkedHashMap'), ('112', 'pppp', 'groupId', '', '255', '0', '0', '1', '2018-12-21 05:17:45', '2018-12-21 05:17:45', null, 'plugin', 'java.lang.String'), ('113', 'pppp', 'artifactId', '', '255', '0', '0', '1', '2018-12-21 05:17:45', '2018-12-21 05:17:45', null, 'plugin', 'java.lang.String'), ('114', 'ooo', 'Message', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, '', 'java.util.LinkedHashMap'), ('115', 'ooo', 'Request', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Message', 'java.util.LinkedHashMap'), ('116', 'ooo', 'Signature', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Message', 'java.util.LinkedHashMap'), ('117', 'ooo', 'SPName', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('118', 'ooo', 'SPNo', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('119', 'ooo', 'RqUId', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('120', 'ooo', 'TranCode', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('121', 'ooo', 'TranDate', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('122', 'ooo', 'TranTime', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('123', 'ooo', 'ChannelNo', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('124', 'ooo', 'CoopCustNo', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('125', 'ooo', 'ProductCd', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('126', 'ooo', 'IsConfirm', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('127', 'ooo', 'CustName', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('128', 'ooo', 'IdNo', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('129', 'ooo', 'ExpDay', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('130', 'ooo', 'MobllePhone', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('131', 'ooo', 'BindCardNo', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('132', 'ooo', 'CardType', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('133', 'ooo', 'ReservedPhone', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('134', 'ooo', 'EacctNo', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('135', 'ooo', 'Reserve1', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('136', 'ooo', 'Reserve2', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Request', 'java.lang.String'), ('137', 'ooo', 'SignedInfo', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Signature', 'java.util.LinkedHashMap'), ('138', 'ooo', 'SignatureValue', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Signature', 'java.lang.String'), ('139', 'ooo', 'CanonicalizationMethod', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'SignedInfo', 'java.lang.String'), ('140', 'ooo', 'SignatureMethod', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'SignedInfo', 'java.lang.String'), ('141', 'ooo', 'Reference', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'SignedInfo', 'java.util.LinkedHashMap'), ('142', 'ooo', 'Transforms', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Reference', 'java.util.LinkedHashMap'), ('143', 'ooo', 'DigestMethod', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Reference', 'java.lang.String'), ('144', 'ooo', 'DigestValue', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Reference', 'java.lang.String'), ('145', 'ooo', 'Transform', '', '255', '0', '0', '1', '2018-12-21 05:18:46', '2018-12-21 05:18:46', null, 'Transforms', 'java.lang.String');
COMMIT;

-- ----------------------------
--  Table structure for `msg_mapping`
-- ----------------------------
DROP TABLE IF EXISTS `msg_mapping`;
CREATE TABLE `msg_mapping` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `interface_id` varchar(10) NOT NULL COMMENT '商户接口表id',
  `in_msg_id` int(10) NOT NULL COMMENT '接入报文配置表id',
  `in_msg_param_name` varchar(50) DEFAULT NULL,
  `out_msg_id` int(10) NOT NULL COMMENT '接口分发配置表id',
  `out_msg_param_name` varchar(50) DEFAULT NULL,
  `is_activated` tinyint(1) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`,`interface_id`,`in_msg_id`,`out_msg_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `msg_mapping`
-- ----------------------------
BEGIN;
INSERT INTO `msg_mapping` VALUES ('1', 'ooo', '115', 'Request', '63', 'Request', '1', '2018-12-26 01:54:24', '2018-12-26 01:54:24'), ('2', 'ooo', '117', 'SPName', '64', 'SPName', '1', '2018-12-26 01:54:24', '2018-12-26 01:54:24'), ('3', 'ooo', '118', 'SPNo', '65', 'SPNo', '1', '2018-12-26 01:54:24', '2018-12-26 01:54:24'), ('4', 'ooo', '119', 'RqUId', '66', 'RqUId', '1', '2018-12-26 01:54:24', '2018-12-26 01:54:24'), ('5', 'ooo', '120', 'TranCode', '67', 'TranCode', '1', '2018-12-26 01:54:24', '2018-12-26 01:54:24'), ('6', 'ooo', '121', 'TranDate', '68', 'TranDate', '1', '2018-12-26 01:54:24', '2018-12-26 01:54:24'), ('7', 'ooo', '122', 'TranTime', '69', 'TranTime', '1', '2018-12-26 01:54:24', '2018-12-26 01:54:24'), ('8', 'ooo', '123', 'ChannelNo', '70', 'ChannelNo', '1', '2018-12-26 01:54:24', '2018-12-26 01:54:24'), ('9', 'ooo', '124', 'CoopCustNo', '71', 'CoopCustNo', '1', '2018-12-26 01:54:24', '2018-12-26 01:54:24'), ('10', 'ooo', '125', 'ProductCd', '72', 'ProductCd', '1', '2018-12-26 01:54:24', '2018-12-26 01:54:24'), ('11', 'ooo', '126', 'IsConfirm', '73', 'IsConfirm', '1', '2018-12-26 01:54:24', '2018-12-26 01:54:24'), ('12', 'ooo', '127', 'CustName', '74', 'CustName', '1', '2018-12-26 01:54:24', '2018-12-26 01:54:24'), ('13', 'ooo', '128', 'IdNo', '75', 'IdNo', '1', '2018-12-26 01:54:24', '2018-12-26 01:54:24'), ('14', 'ooo', '129', 'ExpDay', '76', 'ExpDay', '1', '2018-12-26 01:54:24', '2018-12-26 01:54:24'), ('15', 'ooo', '130', 'MobllePhone', '77', 'MobllePhone', '1', '2018-12-26 01:54:24', '2018-12-26 01:54:24'), ('16', 'ooo', '131', 'BindCardNo', '78', 'BindCardNo', '1', '2018-12-26 01:54:24', '2018-12-26 01:54:24'), ('17', 'ooo', '132', 'CardType', '79', 'CardType', '1', '2018-12-26 01:54:25', '2018-12-26 01:54:25'), ('18', 'ooo', '133', 'ReservedPhone', '80', 'ReservedPhone', '1', '2018-12-26 01:54:25', '2018-12-26 01:54:25'), ('19', 'ooo', '134', 'EacctNo', '81', 'EacctNo', '1', '2018-12-26 01:54:25', '2018-12-26 01:54:25'), ('20', 'ooo', '136', 'Reserve2', '83', 'Reserve2', '1', '2018-12-26 01:54:25', '2018-12-26 01:54:25');
COMMIT;

-- ----------------------------
--  Table structure for `msg_out_conf`
-- ----------------------------
DROP TABLE IF EXISTS `msg_out_conf`;
CREATE TABLE `msg_out_conf` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `api_id` varchar(10) NOT NULL COMMENT '接口表id',
  `parent_node` varchar(255) DEFAULT NULL COMMENT '父节点',
  `param_name` varchar(50) DEFAULT NULL COMMENT '字段名',
  `param_note` varchar(50) DEFAULT NULL COMMENT '字段注释',
  `param_type` varchar(50) DEFAULT NULL COMMENT '字段数据类型',
  `param_length` int(9) DEFAULT NULL COMMENT '字段长度',
  `is_empty` tinyint(1) DEFAULT NULL COMMENT '是否可空',
  `is_activated` tinyint(1) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `encrypt_strategy` int(3) NOT NULL DEFAULT '0' COMMENT '参数0，1，2，3，4。0表示这个字段不需要处理。1的话表示这个字段和他包含的报文体需要加密，2的话表示这个字段和他包含的报文体需要签名,3表示这个字段需要解密，4表示这个字段需要验证签名',
  PRIMARY KEY (`id`,`api_id`)
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `msg_out_conf`
-- ----------------------------
BEGIN;
INSERT INTO `msg_out_conf` VALUES ('63', 'ooo', '', 'Request', '', 'java.util.LinkedHashMap', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('64', 'ooo', 'Request', 'SPName', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('65', 'ooo', 'Request', 'SPNo', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('66', 'ooo', 'Request', 'RqUId', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('67', 'ooo', 'Request', 'TranCode', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('68', 'ooo', 'Request', 'TranDate', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('69', 'ooo', 'Request', 'TranTime', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('70', 'ooo', 'Request', 'ChannelNo', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('71', 'ooo', 'Request', 'CoopCustNo', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('72', 'ooo', 'Request', 'ProductCd', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('73', 'ooo', 'Request', 'IsConfirm', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('74', 'ooo', 'Request', 'CustName', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('75', 'ooo', 'Request', 'IdNo', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('76', 'ooo', 'Request', 'ExpDay', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('77', 'ooo', 'Request', 'MobllePhone', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('78', 'ooo', 'Request', 'BindCardNo', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('79', 'ooo', 'Request', 'CardType', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('80', 'ooo', 'Request', 'ReservedPhone', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('81', 'ooo', 'Request', 'EacctNo', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('82', 'ooo', 'Request', 'Reserve1', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0'), ('83', 'ooo', 'Request', 'Reserve2', '', 'java.lang.String', '255', '0', '1', '2018-12-20 19:59:58', '2018-12-20 19:59:58', '0');
COMMIT;

-- ----------------------------
--  Table structure for `partner_info`
-- ----------------------------
DROP TABLE IF EXISTS `partner_info`;
CREATE TABLE `partner_info` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `partner_code` varchar(50) NOT NULL COMMENT '商户编号',
  `partner_name` varchar(50) DEFAULT NULL COMMENT '商户名称',
  `msg_in_type` varchar(10) DEFAULT NULL COMMENT 'xml,json...',
  `secret_id` int(10) DEFAULT NULL COMMENT '对应加解密配置id',
  `msg_out_type` varchar(10) DEFAULT NULL COMMENT 'xml,json',
  `is_activate` tinyint(1) DEFAULT NULL COMMENT '是否激活',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`,`partner_code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `partner_info`
-- ----------------------------
BEGIN;
INSERT INTO `partner_info` VALUES ('1', 'xs', 'xs', 'XML', '1', 'XML', '1', '2018-12-18 18:40:57', '2018-12-19 03:06:19'), ('2', 'yl', 'yl', 'XML', '2', 'JSON', '1', '2018-12-21 19:16:27', '2018-12-21 19:16:29');
COMMIT;

-- ----------------------------
--  Table structure for `rate`
-- ----------------------------
DROP TABLE IF EXISTS `rate`;
CREATE TABLE `rate` (
  `rate_key` varchar(255) COLLATE utf8_bin NOT NULL,
  `expiration` datetime DEFAULT NULL,
  `remaining` bigint(20) DEFAULT NULL,
  `remaining_quota` bigint(20) DEFAULT NULL,
  `reset` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`rate_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Table structure for `ratelimite_info`
-- ----------------------------
DROP TABLE IF EXISTS `ratelimite_info`;
CREATE TABLE `ratelimite_info` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `api_id` varchar(50) NOT NULL COMMENT '商户编码',
  `ratelimite_type` varchar(10) DEFAULT NULL COMMENT '限流措施',
  `ratelimite_size` int(9) DEFAULT NULL COMMENT '限流大小',
  `direct_transmit` tinyint(1) DEFAULT NULL COMMENT '是否透传',
  `is_activated` tinyint(1) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`,`api_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `secret_info`
-- ----------------------------
DROP TABLE IF EXISTS `secret_info`;
CREATE TABLE `secret_info` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `partner_code` varchar(50) NOT NULL COMMENT '商户编码',
  `encrypt_type` varchar(50) DEFAULT NULL COMMENT '加解密算法类型',
  `is_encrypt_hardware` tinyint(1) DEFAULT NULL COMMENT '是否硬件加解密',
  `encrypt_hardware_ip` varchar(30) DEFAULT NULL COMMENT '加密机地址',
  `private_key_path` varchar(100) DEFAULT NULL COMMENT '私钥路径',
  `public_key_path` varchar(100) DEFAULT NULL COMMENT '公钥路径',
  `is_activated` tinyint(1) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `encrypt_hardware_port` int(11) DEFAULT NULL,
  `sign_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `sign_info`
-- ----------------------------
DROP TABLE IF EXISTS `sign_info`;
CREATE TABLE `sign_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `is_activated` bigint(20) DEFAULT NULL,
  `partner_code` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `private_key_path` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `public_key_path` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `sign_id` bigint(20) DEFAULT NULL,
  `sign_type` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Records of `sign_info`
-- ----------------------------
BEGIN;
INSERT INTO `sign_info` VALUES ('1', '2018-12-26 15:03:14', '1', 'xs', '/private', '/public', '333', 'RSA', '2018-12-26 15:03:37');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
